<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="UTF-8" />
    <meta http-equiv="X-UA-Compatible" content="IE=edge" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    <title>Document</title>
  </head>
  <body></body>
</html>
<script>
  let str = "";
  // 封面图
  let cover= [
    ['https://sdcdn.io/mac/cn/mac_sku_S4K001_1x1_0.png?width=1080&height=1080','https://sdcdn.io/mac/cn/mac_sku_S4K001_1x1_0.png?width=1080&height=1080','https://sdcdn.io/mac/cn/mac_sku_NX6605_1x1_0.png?width=1080&height=1080'],
    ['https://sdcdn.io/mac/cn/mac_sku_MYH211_1x1_0.png?width=1080&height=1080','https://sdcdn.io/mac/cn/mac_sku_SRLA01_1x1_0.png?width=1080&height=1080','https://sdcdn.io/mac/cn/mac_sku_NXAY01_1x1_0.png?width=1080&height=1080'],
    ['https://sdcdn.io/mac/cn/mac_sku_SLEH01_1x1_0.png?width=1080&height=1080','https://sdcdn.io/mac/cn/mac_sku_SCAW09_1x1_0.png?width=1080&height=1080','https://sdcdn.io/mac/cn/mac_sku_M25027_1x1_0.png?width=1080&height=1080'],
      ['https://sdcdn.io/mac/cn/mac_sku_S6H201_1x1_0.png?width=1080&height=1080','https://sdcdn.io/mac/cn/mac_sku_S6H201_1x1_0.png?width=1080&height=1080','https://sdcdn.io/mac/cn/mac_sku_S6H201_1x1_0.png?width=1080&height=1080'],
      ['https://sdcdn.io/mac/cn/mac_sku_SNLK02_1x1_0.png?width=1080&height=1080','https://sdcdn.io/mac/cn/mac_sku_SNLK02_1x1_0.png?width=1080&height=1080','https://sdcdn.io/mac/cn/mac_sku_SNLK02_1x1_0.png?width=1080&height=1080']
    ]
    // 标题
    let title=[
      [],
      [],
      [],
      ['魅可#137锥型晕色长刷'],
      ['「巴洛克限定」秋季迷境系列保湿控妆喷雾']
    ]
    // 价格
  let price=[
      [],
      [],
      [],
      ['425'],
      ['220']
  ]
  // 详情图
  let pic=[
      [],
      [],
      [],
      [],
      ['https://sdcdn.io/mac/cn/mac_sku_SNLK02_1x1_0.png?width=1080&height=1080']
  ]
  // 详情介绍
  let detail=[
      [],
      [],
      [],
      ['137S Long Blending'],
      ['PREP+PRIME FIX / Tempting Fate']
  ]
 
  // 产品规格
  let modul=[
      [],
      [],
      [],
      ['#137'],
      []
  ]
  // 产品销量
  let count=[
      [],
      [],
      [],
      [],
      []
  ]
  // 产品库存
  let allCount=[
      [],
      [],
      [],
      [],
      []
  ]
  let arr = ["唇妆", "底妆", "眼妆", "刷具", "护肤"];
  for (let i = 0; i < 100; i++) {
    let cid = Math.ceil(Math.random() * 5);
    // let img = imgArr[cid-1]
    let type = arr[cid - 1];
    console.log(cover)
     cover = cover[cid - 1];
     title = title[cid - 1];
     price = price[cid - 1];
     pic = pic[cid - 1];
     detail = detail[cid - 1];
     modul = modul[cid - 1];
     count = count[cid - 1];
     allCount = allCount[cid - 1];
    str += `INSERT INTO product VALUES(null, ${cid},'${title}', 'red', '${price}', '${cover}', '${type}' , '${count}', ${allCount}, '${pic}', '${detail}', '${modul}', ${new Date().getTime()});`;
    // count++;
  }
  console.log(str);
</script>

INSERT INTO product VALUES(null, 4,'title1', 'red', 199, 'http', '刷具' , 10,
100, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO product
VALUES(null, 2,'title1', 'red', 199, 'http', '底妆' , 10, 101, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 1,'title1',
'red', 199, 'http', '唇妆' , 10, 102, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 1,'title1', 'red', 199, 'http',
'唇妆' , 10, 103, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 4,'title1', 'red', 199, 'http', '刷具' , 10, 104, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 5,'title1',
'red', 199, 'http', '护肤' , 10, 105, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 3,'title1', 'red', 199, 'http',
'眼妆' , 10, 106, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 5,'title1', 'red', 199, 'http', '护肤' , 10, 107, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 2,'title1',
'red', 199, 'http', '底妆' , 10, 108, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 4,'title1', 'red', 199, 'http',
'刷具' , 10, 109, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 5,'title1', 'red', 199, 'http', '护肤' , 10, 110, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 5,'title1',
'red', 199, 'http', '护肤' , 10, 111, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 4,'title1', 'red', 199, 'http',
'刷具' , 10, 112, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 3,'title1', 'red', 199, 'http', '眼妆' , 10, 113, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 5,'title1',
'red', 199, 'http', '护肤' , 10, 114, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 3,'title1', 'red', 199, 'http',
'眼妆' , 10, 115, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 2,'title1', 'red', 199, 'http', '底妆' , 10, 116, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 1,'title1',
'red', 199, 'http', '唇妆' , 10, 117, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 3,'title1', 'red', 199, 'http',
'眼妆' , 10, 118, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 5,'title1', 'red', 199, 'http', '护肤' , 10, 119, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 2,'title1',
'red', 199, 'http', '底妆' , 10, 120, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 2,'title1', 'red', 199, 'http',
'底妆' , 10, 121, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 3,'title1', 'red', 199, 'http', '眼妆' , 10, 122, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 4,'title1',
'red', 199, 'http', '刷具' , 10, 123, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 4,'title1', 'red', 199, 'http',
'刷具' , 10, 124, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 4,'title1', 'red', 199, 'http', '刷具' , 10, 125, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 5,'title1',
'red', 199, 'http', '护肤' , 10, 126, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 1,'title1', 'red', 199, 'http',
'唇妆' , 10, 127, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 1,'title1', 'red', 199, 'http', '唇妆' , 10, 128, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 3,'title1',
'red', 199, 'http', '眼妆' , 10, 129, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 1,'title1', 'red', 199, 'http',
'唇妆' , 10, 130, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 2,'title1', 'red', 199, 'http', '底妆' , 10, 131, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 2,'title1',
'red', 199, 'http', '底妆' , 10, 132, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 3,'title1', 'red', 199, 'http',
'眼妆' , 10, 133, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 5,'title1', 'red', 199, 'http', '护肤' , 10, 134, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 4,'title1',
'red', 199, 'http', '刷具' , 10, 135, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 1,'title1', 'red', 199, 'http',
'唇妆' , 10, 136, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 2,'title1', 'red', 199, 'http', '底妆' , 10, 137, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 1,'title1',
'red', 199, 'http', '唇妆' , 10, 138, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 3,'title1', 'red', 199, 'http',
'眼妆' , 10, 139, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 3,'title1', 'red', 199, 'http', '眼妆' , 10, 140, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 2,'title1',
'red', 199, 'http', '底妆' , 10, 141, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 3,'title1', 'red', 199, 'http',
'眼妆' , 10, 142, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 5,'title1', 'red', 199, 'http', '护肤' , 10, 143, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 1,'title1',
'red', 199, 'http', '唇妆' , 10, 144, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 4,'title1', 'red', 199, 'http',
'刷具' , 10, 145, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 2,'title1', 'red', 199, 'http', '底妆' , 10, 146, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 4,'title1',
'red', 199, 'http', '刷具' , 10, 147, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 3,'title1', 'red', 199, 'http',
'眼妆' , 10, 148, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 1,'title1', 'red', 199, 'http', '唇妆' , 10, 149, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 1,'title1',
'red', 199, 'http', '唇妆' , 10, 150, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 4,'title1', 'red', 199, 'http',
'刷具' , 10, 151, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 4,'title1', 'red', 199, 'http', '刷具' , 10, 152, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 4,'title1',
'red', 199, 'http', '刷具' , 10, 153, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 3,'title1', 'red', 199, 'http',
'眼妆' , 10, 154, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 3,'title1', 'red', 199, 'http', '眼妆' , 10, 155, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 5,'title1',
'red', 199, 'http', '护肤' , 10, 156, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 4,'title1', 'red', 199, 'http',
'刷具' , 10, 157, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 1,'title1', 'red', 199, 'http', '唇妆' , 10, 158, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 1,'title1',
'red', 199, 'http', '唇妆' , 10, 159, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 3,'title1', 'red', 199, 'http',
'眼妆' , 10, 160, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 3,'title1', 'red', 199, 'http', '眼妆' , 10, 161, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 5,'title1',
'red', 199, 'http', '护肤' , 10, 162, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 2,'title1', 'red', 199, 'http',
'底妆' , 10, 163, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 4,'title1', 'red', 199, 'http', '刷具' , 10, 164, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 1,'title1',
'red', 199, 'http', '唇妆' , 10, 165, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 5,'title1', 'red', 199, 'http',
'护肤' , 10, 166, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 3,'title1', 'red', 199, 'http', '眼妆' , 10, 167, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 4,'title1',
'red', 199, 'http', '刷具' , 10, 168, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 5,'title1', 'red', 199, 'http',
'护肤' , 10, 169, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 4,'title1', 'red', 199, 'http', '刷具' , 10, 170, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 1,'title1',
'red', 199, 'http', '唇妆' , 10, 171, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 5,'title1', 'red', 199, 'http',
'护肤' , 10, 172, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 2,'title1', 'red', 199, 'http', '底妆' , 10, 173, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 3,'title1',
'red', 199, 'http', '眼妆' , 10, 174, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 3,'title1', 'red', 199, 'http',
'眼妆' , 10, 175, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 1,'title1', 'red', 199, 'http', '唇妆' , 10, 176, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 3,'title1',
'red', 199, 'http', '眼妆' , 10, 177, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 3,'title1', 'red', 199, 'http',
'眼妆' , 10, 178, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 1,'title1', 'red', 199, 'http', '唇妆' , 10, 179, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 1,'title1',
'red', 199, 'http', '唇妆' , 10, 180, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 4,'title1', 'red', 199, 'http',
'刷具' , 10, 181, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 4,'title1', 'red', 199, 'http', '刷具' , 10, 182, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 4,'title1',
'red', 199, 'http', '刷具' , 10, 183, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 4,'title1', 'red', 199, 'http',
'刷具' , 10, 184, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 5,'title1', 'red', 199, 'http', '护肤' , 10, 185, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 4,'title1',
'red', 199, 'http', '刷具' , 10, 186, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 4,'title1', 'red', 199, 'http',
'刷具' , 10, 187, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 2,'title1', 'red', 199, 'http', '底妆' , 10, 188, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 1,'title1',
'red', 199, 'http', '唇妆' , 10, 189, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 5,'title1', 'red', 199, 'http',
'护肤' , 10, 190, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 2,'title1', 'red', 199, 'http', '底妆' , 10, 191, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 5,'title1',
'red', 199, 'http', '护肤' , 10, 192, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 2,'title1', 'red', 199, 'http',
'底妆' , 10, 193, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 4,'title1', 'red', 199, 'http', '刷具' , 10, 194, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 2,'title1',
'red', 199, 'http', '底妆' , 10, 195, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 3,'title1', 'red', 199, 'http',
'眼妆' , 10, 196, 'http1', 'detail', '100*100', 1343434343443);INSERT INTO
product VALUES(null, 1,'title1', 'red', 199, 'http', '唇妆' , 10, 197, 'http1',
'detail', '100*100', 1343434343443);INSERT INTO product VALUES(null, 4,'title1',
'red', 199, 'http', '刷具' , 10, 198, 'http1', 'detail', '100*100',
1343434343443);INSERT INTO product VALUES(null, 1,'title1', 'red', 199, 'http',
'唇妆' , 10, 199, 'http1', 'detail', '100*100', 1343434343443);
